﻿CREATE TABLE [trUser].[tblDriverRequests] (
    [IDDriverRequest]      BIGINT   IDENTITY (1, 1) NOT NULL,
    [IDDriver]             BIGINT   NOT NULL,
    [IDPassenger]          BIGINT   NOT NULL,
    [DateRequested]        DATETIME NOT NULL,
    [DateRequestCompleted] DATETIME NULL,
    [DateCreated]          DATETIME CONSTRAINT [DF_tblDriverRequests_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]          DATETIME NULL,
    [DateInactive]         DATETIME NULL,
    CONSTRAINT [PK_tblDriverRequests] PRIMARY KEY CLUSTERED ([IDDriverRequest] ASC)
);

